package homework6;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class DelStudent {
	public DelStudent() {
		try {
		      Class.forName("com.mysql.cj.jdbc.Driver");     //加载MYSQL JDBC驱动程序   
		      //Class.forName("org.gjt.mm.mysql.Driver");
		    }
		    catch (Exception e) {
		      e.printStackTrace();
		    }
//		try {
//		      Class.forName("com.mysql.cj.jdbc.Driver");     //加载MYSQL JDBC驱动程序   
//		      //Class.forName("org.gjt.mm.mysql.Driver");
//		     System.out.println("Success loading Mysql Driver!");
//		    }
//		    catch (Exception e) {
//		      System.out.print("Error loading Mysql Driver!");
//		      e.printStackTrace();
//		    }
	}
	public boolean delete(String sID) {
		boolean s=false;
		try {
	        Connection connect = DriverManager.getConnection(
	            "jdbc:mysql://localhost:3306/student","root","root");
	             //连接URL为   jdbc:mysql//服务器地址/数据库名  ，后面的2个参数分别是登陆用户名和密码

	        System.out.println("Success connect Mysql server!");
	        Statement stmt = connect.createStatement();
	        
	        int rs = stmt.executeUpdate("delete from student where ID="+sID);
	        
	        if(rs==1) {
	        	s=true;
	        }else {
	        	s=false;
	        }
	      }
	    catch (Exception e) {
	       System.out.print("get data error!");
	       e.printStackTrace();
        }
		return s;
		
	}
}
